食堂餐厅管理系统开发

package com.baidu.util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class MysqlUtil { //1銆侀渶瑕佽处鍙枫�佸瘑鐮併�乁RL銆侀┍鍔ㄥ垱寤轰竴涓繛鎺ヤ細璇� private static String user="root";//濡傛灉鏄痵qlserver杈撳叆浠栫殑璐﹀彿 private static String password="123456"; //jdbc:杞欢鍚嶏細//localhost:3306/鏁版嵁搴撳悕 Data銆傘�傘�傘��= private static String url="jdbc:mysql://localhost:3306/test?characterEncoding=utf-8"; private static String Driver="com.mysql.jdbc.Driver"; // 鍙嶅皠椹卞姩 static{ try { Class.forName(Driver); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } } //鑾峰彇涓�涓細璇濓紙java涓庢暟鎹簱鐨勪細璇濓級 //JDBC: java database basic connection public Connection getConn() throws SQLException{ // 閫氳繃椹卞姩绠＄悊鍣ㄧ殑getConnection鏂规硶鑾峰彇涓�涓細璇� Connection conn=DriverManager.getConnection(url, user, password); System.out.println("连接数据库成功！"); return conn; } //测试查询 public void test() throws SQLException { //1、获取一个会话、连接（java和数据库的连接） Connection co=getConn(); //2\创建一个运输工具 Statement st=co.createStatement(); //3\让statement运送sql到数据库去执行 String sql="select password from user where account='123'"; ResultSet re = st.executeQuery(sql); while(re.next()){ System.out.println(re.getString("password")); } } //测试删除 public void testde() throws SQLException { Connection conn=DriverManager.getConnection(url, user, password); Statement st = conn.createStatement(); String sql="delete from user where account='886'"; int count=st.executeUpdate(sql); if(count>0) { System.out.println("删除成功"); }else { System.out.println("删除失败，可能是没有该数据"); } System.out.println(count); } public void testad() throws SQLException { String bookCode="123"; int bookcode=Integer.parseInt(bookCode); Connection con=getConn(); Statement stat=con.createStatement(); String sql="insert into user(account,password) values('112','152')"; int status=stat.executeUpdate(sql); if(status>0){ System.out.println("插入成功"); }else{ System.out.println("插入失败"); } } //测试查询book表 public void testbook() throws SQLException { Connection conn=DriverManager.getConnection(url, user, password); Statement st = conn.createStatement(); //executeQuery用于查询，executeUpdate用于插入、删除、修改 String sql="select * from user"; ResultSet re = st.executeQuery(sql); while(re.next()) { //通过列名获得列名的数据 // int a=re.getInt("Id"); // String name=re.getString("bookName"); // Double price=re.getDouble("price"); // System.out.println(a+name+price); //通过列名的序号获取列名的值 String a=re.getString(1); System.out.println(a); } } public static void main(String args[]) throws SQLException{ MysqlUtil my=new MysqlUtil(); // my.getConn(); // my.test(); // my.testde(); my.testbook(); my.testde(); my.testad(); } }