62,614
社区成员
发帖
与我相关
我的任务
分享
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb"; //这里有个疑问:怎样获取自己的本地端口号?
//mydb为数据库
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
import java.sql.*;
public class sqlexam
{
public static void main(String[] args)
{
String strQuery="SELECT * FROM StudentTable";
Connection conn;
Statement stat;
ResultSet rs;
String sSid,sName,sSex,sClass;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServer.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver"+"://localhost:1433;DatabaseName=Student","sa","");
stat=conn.createStatement();
rs=stat.executeQuery(strQuery);
while(rs.next())
{
sSid=rs.getString(1);
sName=rs.getString(2);
sSex=rs.getString(3);
sClass=rs.getString(4);
System.out.println(sSid+" "+sName+" "+sSex+" "+sClass);
}
rs.close();
}
catch(Exception err)
{
err.printStackTrace();
}
}
}