JCreator 连接数据库
import java.sql.*;
//1,连接数据库
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//2,得到链接
Connection ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=spdb","sa","123456");
//3,创建Statement
Statement sm=ct.createStatement();
ResultSet rs=sm.executeQuery("select top 1 * from users where username='"+u+"' and passwd='"+p+"'");
import java.sql.*;
//1,连接数据库
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//2,得到链接
Connection ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=spdb","sa","123456");
//3,创建Statement
Statement sm=ct.createStatement();
ResultSet rs=sm.executeQuery("select top 1 * from users where username='"+u+"' and passwd='"+p+"'");