SQL 怎么和JAVA程序连接

来源:百度知道 编辑:UC知道 时间:2024/06/20 16:58:35

给你一个自己写得代码吧!
这个是连接sql server 2000的数据库的
package com.bling.sql1;

import java.sql.*;

public class SqlTest
{
private String drive="com.microsoft.jdbc.sqlserver.SQLServerDriver";
private String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BLing";
private String user="sa";
private String pass="84004880";

private Connection connect;
private Statement state;
private ResultSet result;

public SqlTest()
{
try
{
Class.forName(drive);
connect=DriverManager.getConnection(url,user,pass);
state=connect.createStatement();
result=state.executeQuery("select * from Blingkk");
while(result.next())
{
System.out.println(result.getString("username"));
System.out.println(result.getString("password"));
}
state.close();