java与mysql数据库连接完整的程序.docVIP

Java Mysql 数据库的连接及简单功能的，有功能划分，管理员和游客界面。 Test.java package jdbcs; import java.sql.*; class Test { String[] st=new String[200]; private Statement statement; ResultSet rs; private int i; private int rs1; public Test(String s1,String s2) throws ClassNotFoundException, SQLException{ String driver = com.mysql.jdbc.Driver; String url = jdbc:mysql://127.0.0.1:3306/bookstore; String user = root; String password = 123456; int i=0; Class.forName(driver); Connection conn = DriverManager.getConnection(url, user, password); if(!conn.isClosed()) System.out.println(连接数据库成功！); statement= conn.createStatement(); } //查询 public void Select() throws SQLException { String sql1 = select * from user; rs = statement.executeQuery(sql1); System.out.println(以下是查询到的数据：); while(rs.next()) { // st[i++]=rs.getString(Name)+ + rs.getString(Password); // System.out.println(st[i-1]); System.out.println(rs.getString(Name)+ + rs.getString(Password)); } } } login.java package jdbcs; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.*; public class login extends JFrame implements ActionListener { JTextField f1; JTextField f2; public login() { Container ct = getContentPane(); ct.setLayout(new GridLayout(3,2)); JLabel l1 = new JLabel(name); JLabel l2 = new JLabel(password); f1 = new JTextField(15); f2 = new JTextField(15); JButton b1 = new JButton(确定); JButton b2= new JButton(重置); ct.add(new Label(Name)); ct.add(f1); ct.add(new Label(Password)); ct.add(f2); ct.add(b1); ct.add(b2); b1.addActionListener(new Enter()); b2.addActionListener(new ReWrite()); setTitle(login); setSize(300,120); setVisible(true); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } class ReWrite implements ActionListener{ public void actionPerformed(ActionEvent