java sqlhelper_JAVA版SqlHelper

//JAVA版SqlHelper

packagecom.test.Dao;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importjava.sql.Statement;importjava.util.ArrayList;importjava.util.Collections;importjava.util.HashMap;importjava.util.List;importjava.util.Map;importjavax.servlet.jsp.jstl.sql.Result;importjavax.servlet.jsp.jstl.sql.ResultSupport;public classSqlHelper {publicString query(String sql)

{

String result="";try{

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

Connection conn= DriverManager.getConnection("jdbc:sqlserver://116.255.154.99;DatabaseName=test;user=sa;password=Tcqbb1989");

String sql1= "select * from article";

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(sql1);while(rs.next()){

result+=rs.getString(1)+"===="+rs.getString(2)+"";

}

}catch(Exception e){

result+=e.getMessage();

}returnresult;

}publicList query2(String sql)

{

ResultSet result= null;try{

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

Connection conn= DriverManager.getConnection("jdbc:sqlserver://116.255.154.99;DatabaseName=test;user=sa;password=Tcqbb1989");

String sql1= "select * from article";

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(sql1);returnresultSetToList(rs);

}catch(Exception e){

}return null;

}public intexcute(String sql)

{

String result="";int rows1 =0;try{

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

Connection conn= DriverManager.getConnection("jdbc:sqlserver://116.255.154.99;DatabaseName=test;user=sa;password=Tcqbb1989");

Statement stmt=conn.createStatement();

rows1=stmt.executeUpdate(sql);

}catch(Exception e){

result+=e.getMessage();

}returnrows1;

}public List resultSetToList(ResultSet rs) throwsjava.sql.SQLException {if (rs == null)returnCollections.EMPTY_LIST;

ResultSet md= (ResultSet) rs.getMetaData(); //得到结果集(rs)的结构信息，比如字段数、字段名等

int columnCount = ((ResultSetMetaData) md).getColumnCount(); //返回此 ResultSet 对象中的列数

List list = newArrayList();

Map rowData= newHashMap();while(rs.next()) {

rowData= newHashMap(columnCount);for (int i = 1; i <= columnCount; i++) {

rowData.put(((ResultSetMetaData) md).getColumnName(i), rs.getObject(i));

}

list.add(rowData);

System.out.println("list:" +list.toString());

}returnlist;

}

}