java实现数据库查询_用JAVA实现数据库查询

import java.sql.*;

public class MSSQLText

{

public static void main(String args[])

{

String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind";

String user="sa";//这里替换成你自已的数据库用户名

String password="sa";//这里替换成你自已的数据库用户密码

String sqlStr="select CustomerID, CompanyName, ContactName from Customers";

try

{ //这里的异常处理语句是必需的.否则不能通过编译!

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

System.out.println("类实例化成功!");

Connection con = DriverManager.getConnection(url,user,password);

System.out.println("创建连接对像成功!");

Statement st = con.createStatement();

System.out.println("创建Statement成功!");

ResultSet rs = st.executeQuery(sqlStr);

System.out.println("操作数据表成功!");

System.out.println("----------------!");

while(rs.next())

{

System.out.print(rs.getString("CustomerID") + " ");

System.out.print(rs.getString("CompanyName") + " ");

System.out.println(rs.getString("ContactName"));

}

rs.close();

st.close();

con.close();

}

catch(Exception err){

err.printStackTrace(System.out);

}

}

}