jdbc操作mysql数据库实例


            本文实例讲述了jdbc操作mysql数据库的方法。分享给大家供大家参考。具体如下：





import java.sql.*;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

class conn{

 String url="jdbc:mysql://127.0.0.1/nariData";

 final String user = "nari";

 final String pass = "nariacc";

 Connection conn = null;

 Statement st = null;

 ResultSet rs = null;

 conn(){

  try{

   Class.forName("com.mysql.jdbc.Driver");

  }catch(Exception e){

   e.printStackTrace();

  }

  try{

   System.out.println("in DBManager");

   conn = DriverManager.getConnection(url, user, pass);

   String sql = "create table test (id int, uid int)";

   st = conn.createStatement();

   st.execute(sql);

  }catch(Exception e){

   e.printStackTrace();

  }

 }

 void insert(){

  try{

   for(int i=0;i<10;i++){

    String sql = "insert into test values("+i+","+i+")";

    st.execute(sql);

   }

  }catch(Exception e){

   e.printStackTrace();

  }

 }

 void query(){

  try{

   String sql = "select * from test ";

   rs = st.executeQuery(sql);

   while(rs.next()){

    System.out.print("res1: "+rs.getInt(1)+" res2: "+rs.getInt(2)+"\n");

   }

  }catch(Exception e){

   e.printStackTrace();

  }

 }

 void close(){

  try{

   rs.close();

   st.close();

   conn.close();

  }catch(Exception e){

   e.printStackTrace();

  }

 }

}

public class mysqltest {

 public static void main(String[] args) {

  // TODO Auto-generated method stub

  conn a1 = new conn();

  a1.insert();

  a1.query();

  a1.close();

 }

}







希望本文所述对大家的JSP程序设计有所帮助。