《网上书店信息管理系统的设计与实现》 第1页 共34页
附录 全部源代码
package com.shoeShop.db;
import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException;
public class Connect { }
private static Connection con = null;
private static String url=\private static String driver = \private static String user = \private static String pwd = \public static Connection getConnection(){ }
public static void main(String[] args) { }
Connect.getConnection(); try {
Class.forName(driver);
con = DriverManager.getConnection(url, user, pwd); System.out.println(\数据库连接成功！\
} catch (ClassNotFoundException e) {
System.out.println(\驱动加载失败！\
} catch (SQLException e) { } return con;
System.out.println(\数据库连接失败！\
《网上书店信息管理系统的设计与实现》 第2页 共34页 package com.shoeShop.action; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.JPanel;
import com.shoeShop.view.RegisterFrame;
public class docMenuAction implements ActionListener { }
package com.shoeShop.dao;
RegisterFrame register = null; JPanel cusPanel = null; JPanel docPanel = null;
public docMenuAction(RegisterFrame register){ }
public void actionPerformed(ActionEvent e) { }
// TODO Auto-generated method stub register.flag = 1;
//System.out.println(register.flag); register.remove(cusPanel); register.add(docPanel); docPanel.updateUI(); this.register = register;
this.cusPanel = register.cusPanel; this.docPanel = register.docPanel;
《网上书店信息管理系统的设计与实现》 第3页 共34页
import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement;
import com.shoeShop.db.Connect; import com.shoeShop.entity.Buyer; import com.shoeShop.entity.Seller;
public class BuyerDao {
private static Connection conn; private static Statement statement; private static ResultSet resultSet;
//插入数据，用于注册
public int insertBuyer(Buyer buyer){
int flag = 0;
conn = Connect.getConnection(); try {
statement = conn.createStatement(); String
sql
=
\
into
buyer
values('\; //
System.out.println(\flag = statement.executeUpdate(sql); statement.close(); conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
《网上书店信息管理系统的设计与实现》 第4页 共34页 //
}
//通过用户名和密码查询，用于登录
public static Buyer getBuyer(String name,String pwd){
conn = Connect.getConnection(); Buyer buyer = new Buyer(); try {
statement = conn.createStatement();
String sql = \* from buyer where buyer_id='\and pwd = }
e.printStackTrace();
System.out.println(flag); return flag;
'\
}
resultSet = statement.executeQuery(sql); while(resultSet.next()){ }
resultSet.close(); statement.close(); conn.close();
buyer.setId(resultSet.getString(\buyer.setName(resultSet.getString(\buyer.setPwd(resultSet.getString(\buyer.setAddress(resultSet.getString(\
} catch (SQLException e) { }
// TODO Auto-generated catch block e.printStackTrace();
return buyer;
《网上书店信息管理系统的设计与实现》 第5页 共34页 // // // // // // }
package com.shoeShop.dao;
import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList;
import com.shoeShop.db.Connect; import com.shoeShop.entity.Goods; import com.shoeShop.entity.Seller; import com.shoeShop.imp.User;
public class GoodsDao {
private static Connection conn; private static Statement statement; private static ResultSet resultSet;
public static void main(String[] args) { }
BuyerDao dao = new BuyerDao();
System.out.println(dao.getBuyer(\Buyer buyer = new Buyer(); buyer.setId(\
buyer.setName(\长理专卖\buyer.setPwd(\buyer.setAddress(\湖南长沙\dao.insertBuyer(buyer);