Simple connection Database Standard step __ Database

1: The method is not encapsulated in the case:

public class connectiondemo{

public static void Main (string[] args) {

1: Set parameters

String url= "Jdbc:mysql://localhost:3306/dbname?useunicode=true&characterencoding=utf8";

String user= "root";

String pwd= "123456";

Connection Conn=null;

PreparedStatement Pstmt=null;

ResultSet Rs=null;

try{

2 Load Driver

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

3 Getting Connection objects

Conn=drivermanager.getconnection (URL,USER,PWD);

4 Sending SQL statements

String sql= "SELECT * from user where id=?";

Pstmt=conn.preparestatement (SQL);

5 Setting parameters

Pstmt.setnameid (1);

Pstmt.setname ("Lisi");

6 execution

Rs.pstmt.executeQuery ();

7 Extraction Results

while (Rs.next ()) {

int Use_id=rs.getint (); First column

String use_name=rs.getstring ("Usr_name");

System.out.println (use_id+ "T" +use_name);

}

}catch (ClassNotFoundException e) {

E.printstacktrace ();

System.out.println ("Load driven failure");

}catch (SQLException e) {

E.printstacktrace ();

SYSTEM.OUT.PRINTLN ("Get Connection object failed.") ");

}

}

}

}