第一类连接Mysql方法见下图:
第二类连接Mysql方法:(跟第一类差不多,并提供查询操作)
首先在Mysql中建立testjdbc数据库,在该数据库下面建立Student表:
参考代码:
CREATE DATABASE testjdbc Go Use testjdbc Go CREATE TABLE Student( Sno varchar(20), Sname varchar(20), Sage int )查询操作参考代码:
package testjdbc; import java.sql.*; public class JdbcTest { public static void main(String[] args) { String className=null; String url=null; String user=null; String password=null; className="com.mysql.jdbc.Driver"; url="jdbc:mysql://localhost:3306/testjdbc"; user="root"; password="root"; try { Class.forName(className); } catch (Exception e) { System.out.println(className+"driver failed to load."); } try { Connection con= DriverManager.getConnection(url,user,password); Statement stmt=con.createStatement(); ResultSet rs =stmt.executeQuery("select * from student"); ResultSetMetaData rsmd =rs.getMetaData(); int numberOfColumns=rsmd.getColumnCount(); int rowCount=1; while (rs.next()) { for(int i=1;i<=numberOfColumns;i++){ System.out.print(rs.getString(i)+" "); } System.out.println(""); rowCount++; } stmt.close(); con.close(); } catch (Exception e) { System.out.println(e); } } }
查询操作参考代码二:
package testjdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import com.mysql.jdbc.SQLError; public class jdbcTestSelect_2 { public static void main(String[] args) { String className=null; String url=null; String user=null; String password=null; className="com.mysql.jdbc.Driver"; url="jdbc:mysql://localhost:3306/testjdbc"; user="root"; password="root"; try { Class.forName(className); } catch (Exception e) { System.out.println(className+"driver failed to load."); } try { Connection conn= DriverManager.getConnection(url,user,password); Statement stmt =conn.createStatement(); String sql="select * from student"; ResultSet rs =stmt.executeQuery(sql); while (rs.next()) { String Sno=rs.getString(1); String Sname=rs.getString(2); int Sage=rs.getInt(3); System.out.println(Sno+" "+Sname+" "+Sage); stmt.close(); conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } }
插入操作参考代码:
package testjdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Scanner; public class jdbcTestInsert { public static void main(String[] args) { String className=null; String url=null; String user=null; String password=null; className="com.mysql.jdbc.Driver"; url="jdbc:mysql://localhost:3306/testjdbc"; user="root"; password="root"; try { Class.forName(className); } catch (Exception e) { System.out.println(className+"driver failed to load."); } try { Connection conn= DriverManager.getConnection(url,user,password); Statement stmt =conn.createStatement(); String sno,sname; int sage; System.out.println("请输入学号,姓名,年龄"); Scanner cin=new Scanner(System.in); sno=cin.next(); sname=cin.next(); sage=cin.nextInt(); String sql="INSERT INTO student values('"+sno+"','"+sname+"','"+sage+"')"; stmt.execute(sql); stmt.close(); conn.close(); } catch(SQLException e){ e.printStackTrace(); } } }
删除操作参考代码:
package testjdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Scanner; public class jdbcTestDelete { public static void main(String[] args) { // TODO Auto-generated method stub String className=null; String url=null; String user=null; String password=null; className="com.mysql.jdbc.Driver"; url="jdbc:mysql://localhost:3306/testjdbc"; user="root"; password="root"; try { Class.forName(className); } catch (Exception e) { System.out.println(className+"driver failed to load."); } try { Connection conn= DriverManager.getConnection(url,user,password); Statement stmt =conn.createStatement(); System.out.println("请输入要删除的学号:"); Scanner cinScanner=new Scanner(System.in); String snoString=cinScanner.next(); String sqlString="delete from student where Sno="+snoString; stmt.executeUpdate(sqlString); stmt.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } }