JAVA求注释。数据库问题。这个数据源叫什么名

显示全部楼层 · 2011-4-12 13:23:08

/*
*DBConnect.java
*AdminControl.java
*author:liuhaijing
*/

package mydesign;
import java.sql.*;
import java.io.*;
public class DBConnect
{

Connection conn=null;

Statement stmt=null;

ResultSet r=null;

String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=MyDesign";

String username="sa";

String password="933713";

String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";

public DBConnect()

{

try

{

Class.forName(driver);

conn=DriverManager.getConnection(url,username,password);

stmt=conn.createStatement();

}

catch(Exception ex)

{

System.out.print("连接数据库发生错误："+ex.getMessage());

}

}

//ResultSet Query

public ResultSet executeQuery(String sql)

{

try

{

r=stmt.executeQuery(sql);

}

catch(Exception ex)

{

System.out.print("查询发生错误："+ex.getMessage());

}

return r;

}

//executeUpdate

public void executeUpdate(String sql)

{

try

{

stmt.executeUpdate(sql);

}

catch(Exception ex)

{

System.out.print("执行SQL发生错误:"+ex.getMessage());

}

}

//close the conn

public void close()

{

try

{

if(r!=null)r.close();

if(stmt!=null)stmt.close();

if(conn!=null)conn.close();
}
catch(Exception ex)
{
System.out.print("closeconn Error:"+ex.getMessage());
}
}
}

千问 · 2011-4-12 13:23:08

/* *DBConnect.java *AdminControl.java *author:liuhaijing */ 上面的是注释package mydesign;类所属的包import java.sql.*;import java.io.*;上面是导入包public class DBConnect//创建类{
Connection conn=null;创建连接的队形
Statement stmt=null;
ResultSet r=null;//创建结果集
String url="jdbc:microsoft:sqlserver://127.0.0.

千问 · 2011-4-12 13:23:08

数据库是这个：MyDesign
String username="sa";账户
String password="933713";密码
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"; 驱动