成员 | 任务分配 |
---|---|
林小强(组长) | dao包 util包 可视化 |
陈泽役 | model包 可视化 |
项目地址
package util; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; public class JDBCUtil { private static final String URL = "jdbc:mysql://localhost:3306/javadesign?useUnicode" + "=true&characterEncoding=utf-8&useSSL=false&serve" + "rTimezone = GMT"; private static final String USERNAME = "root"; private static final String PASSWORD = "123456"; public static Connection getConnection() throws SQLException { Connection con = null; con = DriverManager.getConnection(URL, USERNAME, PASSWORD); return con; } }
package dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import models.Admin; import util.JDBCUtil; public class AdminDaoImpl implements AdminDao { Connection con; PreparedStatement sql; ResultSet resultSet = null; public Admin getAdminByAdminNumber(String adminNumber) { Admin admin = null; try { con=JDBCUtil.getConnection(); sql = con.prepareStatement("select * from admin where adminnumber=?"); sql.setString(1, adminNumber); resultSet = sql.executeQuery(); if (resultSet.next()) { admin = new Admin(resultSet.getString(1), resultSet.getString(2), resultSet.getString(3)); } resultSet.close(); sql.close(); con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return admin; } }
新的想法:学习一些网络编程技术实现联网点餐