java连接mysql-1

安装jdk（包括jre）并配置路径和测试

安装mysql

1、mysql-5.5.12-win32.msi

2、设置密码，其余默认

3、运行测试

show databases;

show tables;

 

安装apache（可不选）

1、使用压缩版，解压出来

2、配置JAVA_HOME和JAVA_JRE

3、运行bin下startup.bat，开启服务；shutdown.bat关闭服务

 

连接器

1、获得mysql-connector-java-5.1.15-bin.jar

2、在classpath中添加它的路径

 

创建应用程序

1、建立文件ConnectMysql.java，内容如下 

import java.io.*;import java.sql.*;public class ConnectMysql {private String DBDriver="com.mysql.jdbc.Driver";private String url="jdbc:mysql://localhost:3306/test";public Connection conn=null;public ResultSet rs=null;public Statement stmt=null;public ConnectMysql(){try{Class.forName(DBDriver);}catch(java.lang.ClassNotFoundException e){System.out.println("jdbcDriver error!");}}public ResultSet query(String mySql)  throws SQLException{rs=null;try{//Class.forName(DBDriver);conn=DriverManager.getConnection(url,"root","xhp");//有可能出错stmt=conn.createStatement();rs=stmt.executeQuery(mySql);}catch(SQLException e){System.out.print(e.getMessage());}return rs;}public void update(String mySql) throws Exception{stmt=null;try{//Class.forName(DBDriver);conn=DriverManager.getConnection(url,"root","xhp");//有可能出错stmt=conn.createStatement();stmt.executeUpdate(mySql);}catch(SQLException e){System.out.print(e.getMessage());}finally{stmt.close();conn.close();}}public void closeStmt(){try{stmt.close();}catch(SQLException e){System.err.println("closeStmt error");}}public void closeConn(){try{conn.close();}catch(SQLException e){System.err.println("closeConn error");}}public static void main(String[] args){ConnectMysql connMysql=new ConnectMysql();//String sql="select * from employee";String sql="select * from toupiao";try{ResultSet rs=connMysql.query(sql);while(rs.next()){System.out.print(rs.getString("no"));System.out.print(""+rs.getString("name"));System.out.print(""+rs.getString("age"));System.out.print(""+rs.getString("gender"));System.out.print(""+rs.getString("dept"));System.out.print(rs.getString("id"));System.out.print(""+rs.getString("name"));System.out.println(""+rs.getString("num"));}}catch(SQLException e){e.printStackTrace();}finally{connMysql.closeStmt();connMysql.closeConn();}}}

2、转到当前目录，javac ConnectMysql.java；java ConnectMysql

3、运行结果 

1       JSP     12
2       JSF     15
3       Structs 18