ãã1ï¼eclipseå¼åç¯å¢é没æéæmysqlç驱å¨ï¼éè¦ä»ä»¥ä¸å°åä¸è½½è¿æ¥é©±å¨ç¨åºmysql-connector-java-XX-XX-XX.zipï¼
ãã
http://dev.mysql.com/downloads/connector/jãã2ï¼è§£åï¼åªåæ件mysql-connector-java-XX.XX.XX-bin.jarï¼å°å
¶å¼ç¨å°ä½ éè¦è¿æ¥mysqlæ°æ®åºçå·¥ç¨éï¼å¦ï¼æå¨eclipselé建äºä¸ä¸ªæµè¯æ°æ®åºè¿æ¥çå·¥ç¨ConMysqlãå
·ä½æä½å¦ä¸ï¼
ããå¨å·¥ç¨ConMysqlä¸ç¹å»å³é®
ããproperties->Java Build Path->Libraries
ããç¹å»Add External JARS...
ããéå解ååçmysql-connector-java-XX.XX.XX-bin.jar
ãã3.ç¼åæµè¯ä»£ç 1
ããimport java.sql.*;
public class MysqlJdbc {
public static void main(String args[]) {
try {
Class.forName("com.mysql.jdbc.Driver"); //å è½½MYSQL JDBC驱å¨ç¨åº
//Class.forName("org.gjt.mm.mysql.Driver");
System.out.println("Success loading Mysql Driver!");
}
catch (Exception e) {
System.out.print("Error loading Mysql Driver!");
e.printStackTrace();
}
try {
Connection connect = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/mysql","root","");
//è¿æ¥URL为 jdbc:mysql//æå¡å¨å°å/æ°æ®åºå
//åé¢ç2个åæ°åå«æ¯ç»éç¨æ·ååå¯ç
System.out.println("Success connect Mysql server!");
Statement stmt = connect.createStatement();
ResultSet rs = stmt.executeQuery("select * from help_topic");
while (rs.next()) {
System.out.println(rs.getString("name"));
}
}
catch (Exception e) {
System.out.print("get data error!");
e.printStackTrace();
}
}
}
ãã4.ç¼åæµè¯ä»£ç 2
ããimport java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
ããpublic class LoginFrame extends JFrame implements ActionListener{
JLabel label = new JLabel("请è¾å
¥ç¨æ·ååå¯ç ï¼");
JTextField tfName = new JTextField(""); //è¾å
¥ç¨æ·åçææ¬æ¡
JPasswordField tfPassword = new JPasswordField(""); //è¾å
¥å¯ç çå¯ç æ¡
JButton button = new JButton("ç»å½");
public LoginFrame()
{
this.setTitle("ç»å½éªè¯");
button.addActionListener(this);
this.getContentPane().setLayout(new GridLayout(4,1));
this.getContentPane().add(label);
this.getContentPane().add(tfName);
this.getContentPane().add(tfPassword);
this.getContentPane().add(button);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setSize(300,200);
this.setLocation(200,300);
this.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
try{
/*
* è¿æ¥MySQLæ°æ®åº
*/
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/mysql","root","");
Statement stmt=conn.createStatement();
String sql = "select * from account where username='" + tfName.getText() + "'";
sql += " and password='" + tfPassword + "'"; //åå¤æ¥è¯¢è¯å¥
ResultSet rs=stmt.executeQuery( sql );
if( rs.next() )
label.setText("åæ³ç¨æ·"); //身份éªè¯éè¿???
else
label.setText("éæ³ç¨æ·"); //身份éªè¯æ²¡æéè¿?????
}catch(Exception ee){
ee.printStackTrace();
}
}
public static void main(String[] args) {
new LoginFrame();
}
}