dbconn.java

这个是我同学做的

package DataBase;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;



 public class DBConn {
	
	private String sURL="jdbc:mysql://localhost:3306/textonline";
	private String sUser="root";
	private String sPwd="1234";
	private Connection conn=null;
	private Statement sta=null;
	static{
		try {
			Class.forName("org.gjt.mm.mysql.Driver");//加载数据库驱动程序
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
private void openconn(){//打开连接
	try {
		conn=DriverManager.getConnection(sURL,sUser,sPwd);
		sta=conn.createStatement();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
public ResultSet Query(String sql){
 openconn();
 try {
	ResultSet rs=sta.executeQuery(sql);
	return rs;
} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
}
return null;	

}

public int Update(String sql){
	openconn();
int i;
try {
	i=sta.executeUpdate(sql);
	return i;
} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
}
return -1;

}

private void closeconn(){//关闭连接
if(conn!=null){
	try {
		conn.close();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}	
}

//public static void main(String args[]){
////	 int id;
//	 String sno;
////	 String sname;
////	 String ssex;
////	 String sage;
////	 String sxi;
////	 String szhuanye;
////	 String sbanji;
////	 String sxuexiao;
//	DBConn dbconn=new DBConn();
//	String sql="select *from student order by no ";
//   ResultSet rs= dbconn.Query(sql);
//    
//		try {
//			while(rs.next()){
////		 id=rs.getInt("id");		
//				sno=rs.getString("no");
//				System.out.println(sno);
////		 sname=rs.getString("sname");
////		 ssex=rs.getString("ssex");
////		 sage=rs.getString("sage");
////		 sxi=rs.getString("sxi");
////		 szhuanye=rs.getString("szhuanye");
////		 sbanji=rs.getString("sbanji");
////		 sxuexiao=rs.getString("sxuexiao");
////		 System.out.println(sbanji);
////		}
////	} catch (SQLException e) {
////		// TODO Auto-generated catch block
////		e.printStackTrace();
////	}
////
////String no="2005111155";
////String name="无名";
////String sex="男";
////String age="32";
////String sxi="不知道";
////String szhuanye="秘密";
////String sbanji="秘密";
////String sxuexiao="秘密";
////String sql="insert into student(sno,sname,ssex,sage,sxi,szhuanye,sbanji,sxuexiao) values ('"+no+"','"+name+"','"+sex+"','"+age+"','"+sxi+"','"+szhuanye+"','"+sbanji+"','"+sxuexiao+"')";
////System.out.println(dbconn.Update(sql));
//////}
//}
//		} catch (SQLException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}
//}

	

}