毕业论文网上商城系统

package JavaBean;import .*;public class DatabaseConn { String sDBDriver=""; String sContr="jdbc:odbc:Library";//Library 为数据源的名字，建议最好配置的时候与数据库的 名字相同 Connection conn=null; ResultSet rs=null; public DatabaseConn(){ try{ (sDBDriver);//加载驱动器 } catch(ClassNotFoundException e){ (()); } } public ResultSet executeQuery(String sql){//用于查询时调用 try{ conn=(sContr,"",""); Statement stmt=(); rs=(sql); } catch(SQLException e){ (()); } return rs; } public int executeUpdate(String sql) throws SQLException{//用于增、删、改时调用 int num=0; conn=(sContr,"",""); Statement stmt=(); num=(sql); return num; }// 测试数据库的链接 // public static void main(String args[]){// DatabaseConn conn=new DatabaseConn();// ("Connection Success!");// } }

package dataBase;import ;import ;import ;import ;//import ;import ;import ;import ;public class DBHelper { private Connection con; private PreparedStatement pstmt; private ResultSet rs; //静态语句块，加载驱动 static { try { (""); } catch (ClassNotFoundException e) { (); } } public ArrayList findBySql(String sql, ArrayList params, Class c) { con = (); try { pstmt=(sql); doParams(pstmt, params); rs=(); while(()){ /**************************************************/ } } catch (SQLException e) { // TODO Auto-generated catch block (); } return List; } //连接数据库 public Connection getCon() { try { con = ( "jdbc:sqlserver://;databaseName=数据库名", "连接数据库名", "密码"); } catch (SQLException e) { (); } return con; } //关闭所有连接 public void closeAll(ResultSet rs, PreparedStatement pstmt, Connection con) { if (rs != null) { try { (); } catch (SQLException e) { (); } } if (pstmt != null) { try { (); } catch (SQLException e) { (); } } if (con != null) { try { (); } catch (SQLException e) { (); } } } //对数据进行增、删、改 // insert into xx values(?,?); params={"张三","a"}; public void doUpdate(String sql, List params) { con = (); try { pstmt = (sql); doParams(pstmt, params); (); } catch (SQLException e) { (); } finally { closeAll(null, pstmt, con); } } public void doParams(PreparedStatement pstmt, List params) throws SQLException { if (pstmt != null && params != null && () > 0) { for (int i = 0; i < (); i++) { (i + 1, (i)); } } }}

网上商城，也就是网上购物系统，一般可以用asp,jsp,来设计，设计+论文