package com.database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
//连接数据库
public class DbHelper {
protected Connection con;
protected PreparedStatement ml;
protected ResultSet jg;
public void getCon()
{
String str="jdbc:sqlserver://localhost:1433;DatabaseName=student";
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con=DriverManager.getConnection(str,"sa","123456");
}catch(Exception e)
{
e.printStackTrace();
}
}
public void closeAll()
{
if(jg!=null)
try {
jg.close();
} catch (SQLException e) {
e.printStackTrace();
}
if(ml!=null)
try {
ml.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(con!=null)
try{
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
Ajax.zip （13个子文件） 
Ajax src com database 
DbHelper.java 1KB student studentbiz.java 873B entity student.java 293B .project 1KB WebRoot META-INF MANIFEST.MF 39B WEB-INF web.xml 1010B dwr.xml 410B classes com database DbHelper.class 1KB student studentbiz.class 2KB entity student.class 711B lib index.jsp 1KB .mymetadata 285B .classpath 582B .myeclipse 资源评论
