数据库课程设计-点餐系统.rar

package diancan; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Connectsql { String datasourceName=""; String SQL,message=""; //属性 public Connectsql() { //方法一 try { Class.forName("com.microsoft.sqlserver.jdbc.SQLserverDriver"); } catch(Exception e) {} } public void setSQL(String SQL) { //方法二 提取SQL语句 this.SQL=SQL; } public void setDatasourceName(String s) { //方法三 datasourceName=s.trim(); } public String modifyRecord() { //方法四 连接数据库 Connection con=null; Statement sql=null; try { String uri="jdbc:sqlserver://localhost:1433;DatabaseName=diancan"; String id="sa"; String password="123456"; con=DriverManager.getConnection(uri, id, password); sql=con.createStatement(); sql.execute(SQL); message="操作成功"; con.close(); } catch(SQLException e) { message=e.toString(); } return message; } public String getRecord() { //方法五 提取数据库信息 结账 Connection con=null; Statement statement=null; //String a=null; ResultSet rs=null; try { String uri="jdbc:sqlserver://localhost:1433;DatabaseName=diancan"; String id="sa"; String password="123456"; con=DriverManager.getConnection(uri, id, password); statement=con.createStatement(); //statement.execute(SQL); rs=statement.executeQuery(SQL); while(rs.next()) { Showresult1 frame=new Showresult1(rs.getString("consume")); frame.show(); //a.(rs.getString("consume")); //System.out.println(rs.getString("consume")); } rs.close(); //a=rs.getNString("consume"); message="结账成功"; con.close(); } catch(SQLException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } return message; } public String checkRecord() { //方法六 提取数据库信息 查看已点的菜 Connection con=null; Statement statement=null; //String a=null; ResultSet rs=null; try { String uri="jdbc:sqlserver://localhost:1433;DatabaseName=diancan"; String id="sa"; String password="123456"; con=DriverManager.getConnection(uri, id, password); statement=con.createStatement(); //statement.execute(SQL); rs=statement.executeQuery(SQL); while(rs.next()) { Showresult2 frame=new Showresult2(rs.getString("dish_name")); frame.show(); } rs.close(); //a=rs.getNString("consume"); message="查看已点的菜成功"; con.close(); } catch(SQLException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } return message; } }