mysqltest.java

实现java与Mysql数据库连接

import java.sql.*;


public class MySqlTest {

	/**
	 * @param args
	 */
	public static void main(String args[])
   {
	
		String url = "jdbc:mysql://localhost:3306/jiaoxue";
    String user ="root";//这里替换成你自已的数据库用户名
    String password = "123456";//这里替换成你自已的数据库用户密码
    String sqlStr = "SELECT * FROM  student";

    try{   //这里的异常处理语句是必需的.否则不能通过编译!   
        Class.forName("org.gjt.mm.mysql.Driver");
        System.out.println( "类实例化成功!" );

        Connection con = DriverManager.getConnection(url, user, password);

        System.out.println( "创建连接对像成功!" );

        Statement st = con.createStatement();
        System.out.println( "创建Statement成功!" );     
       
       st.executeUpdate("insert into student values(30,'aa',26)");
        System.out.println( "插入成功!" );
        ResultSet rs = st.executeQuery( sqlStr );
        System.out.println( "读取成功!" );
        //st.executeUpdate("delect from student where Sno=1");
       // System.out.println( "删除成功!" );
        System.out.println( "----------------!" );
        
        rs = st.executeQuery( sqlStr );
      while(rs.next())
        {
          System.out.print(rs.getString("Sno") + "   ");
          System.out.print(rs.getString("name") + "   ");
          System.out.println(rs.getString("age") + "   ");
        }
        rs.close();
        st.close();
        con.close();
    }
    catch(Exception err){
        err.printStackTrace(System.out);
    }
  }
}