Question

java中怎样连接数据库与图形界面结合

Answer 1

import java.sql.*;
public class L
{
public static void main(String[] args)
{
String sql;
Connection conn;
Statement stmt;
ResultSet rs;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://数据库地址:数据库端口;DatabaseName=数据库名";
String user="数据库连接名";
String password="数据库连接密码";
conn= DriverManager.getConnection(url,user,password);
stmt=conn.createStatement();
sql="要执行的SQL语句";
rs=stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}