package tk.donghongyujava.sql.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class Test {
public static void main(String[] args) {
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
try{
//装载驱动
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//连接数据库
//端口号可以通过exec sys.sp_readerrorlog 0, 1, 'listening'进行查询
String url="jdbc:sqlserver://localhost:1434;databaseName=larbory";
conn=DriverManager.getConnection(url,"sa","admin1234");
pstmt=conn.prepareStatement("select * from TestAdmin");
rs=pstmt.executeQuery();
System.out.println("连接成功");
while(rs.next()){
System.out.print("ID="+rs.getInt("id")+"\t");
System.out.print("name="+rs.getString("name")+"\t");
System.out.print("pass="+rs.getString("pass")+"\t");
System.out.println();
}
}catch(Exception e){
System.out.println("连接失败");
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class Test {
public static void main(String[] args) {
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
try{
//装载驱动
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//连接数据库
//端口号可以通过exec sys.sp_readerrorlog 0, 1, 'listening'进行查询
String url="jdbc:sqlserver://localhost:1434;databaseName=larbory";
conn=DriverManager.getConnection(url,"sa","admin1234");
pstmt=conn.prepareStatement("select * from TestAdmin");
rs=pstmt.executeQuery();
System.out.println("连接成功");
while(rs.next()){
System.out.print("ID="+rs.getInt("id")+"\t");
System.out.print("name="+rs.getString("name")+"\t");
System.out.print("pass="+rs.getString("pass")+"\t");
System.out.println();
}
}catch(Exception e){
System.out.println("连接失败");
}
}
}