java 连接sql_JAVA连接SQL数据库

importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;importjava.sql.Statement;importjava.sql.ResultSet;/***@authorAdministrator**/publicclas...

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

import java.sql.ResultSet;

/**

* @author Administrator

*

*/

public class sqlServer {

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

String ConnStr="jdbc:microsoft:sqlserver://WINJUE:1433;DatabaseName=library";

ResultSet rs=null;

private Connection conn;

///建立连接//

public sqlServer() {

try {

Class.forName(DBDriver).newInstance();

conn=DriverManager.getConnection(ConnStr,"sa","sa");

}

catch(SQLException e) {

System.out.println(e.getMessage());

}

catch(Exception e) {

System.out.println(e.getMessage());

}

}

public Connection getConn(){ //获取连接方法

return conn;

}

public void insert(String sql) {//增删改

try {

Statement stm=conn.createStatement();

stm.executeUpdate(sql);

System.out.println("操作成功");

}

catch(Exception e){

System.out.println(e.getMessage());

}

}

public ResultSet query(String sql){ //查询

try{

Statement stm=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

rs=stm.executeQuery(sql);

}

catch(Exception e){

System.out.println(e.getMessage());

}

return rs;

}

public static void main(String args[]){

sqlServer conn=new sqlServer();

ResultSet rs=conn.query("select * from Orders");

//conn.insert("delete from BookInfo where BookName =" +"\'悟空传\'");

//conn.insert("insert into BookInfo (BookID,BookName,Author,KeyWord) values (14445678,'悟空传','今何在','孙悟空')");

try{

while(rs.next()){

System.out.print(rs.getString("OrderID"));

//System.out.print(rs.getString("U_age"));

}

rs.close() ;

}

catch (Exception e){

System.out.println(e.getMessage());

}

}

}

请解释每句的含义 越详细越好

各位帮忙啊 好的会再追50分

如果大多都是系统生成的. 那只要指出哪些是自己需要填写的.

比如数据库名字 表什么的.最好详细点.

展开