import java.sql.*; public class Sql { public void connect()
{
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=booksale";
//mydb为数据库
String user="";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
stmt.execute("select * from saleinfo");
ResultSet rs=stmt.getResultSet();
while (rs.next())
{
String id=Integer.toString(rs.getInt("id"));
String name=rs.getString("name");
String date=Integer.toString(rs.getInt("date"));
String salesum=Integer.toString(rs.getInt("salesum"));
System.out.println(id+"\t\t"+name+"\t\t"+date+"\t\t"+salesum);
}
}
catch(Exception e)
{
e.printStackTrace();
} } public static void main(String[] args) {
Sql s=new Sql();
s.connect();
}
我是windows登录sqlserver的方式,该怎么办??
问题补充:我想知道是windows登录sqlserver,如何用java连sqlserver数据库,不是想将sqlserver该成sa登录方式
{
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=booksale";
//mydb为数据库
String user="";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
stmt.execute("select * from saleinfo");
ResultSet rs=stmt.getResultSet();
while (rs.next())
{
String id=Integer.toString(rs.getInt("id"));
String name=rs.getString("name");
String date=Integer.toString(rs.getInt("date"));
String salesum=Integer.toString(rs.getInt("salesum"));
System.out.println(id+"\t\t"+name+"\t\t"+date+"\t\t"+salesum);
}
}
catch(Exception e)
{
e.printStackTrace();
} } public static void main(String[] args) {
Sql s=new Sql();
s.connect();
}
我是windows登录sqlserver的方式,该怎么办??
问题补充:我想知道是windows登录sqlserver,如何用java连sqlserver数据库,不是想将sqlserver该成sa登录方式
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货