JDBC的querry、insert

 

package com.dairui.jdbc;

 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

 

import com.mysql.jdbc.Driver;

import com.mysql.jdbc.PreparedStatement;

 

class Test11 {

private String driver = "com.mysql.jdbc.Driver";

private String url = "jdbc:mysql://localhost:3306/hibernate";

private String username = "root";

private String password = "dairui123";

Connection conn = null;

 

public Connection getConnect() throws SQLException {

try {

Class.forName(driver);

conn = DriverManager.getConnection(url, username, password);

 

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

 

} finally {

}

return conn;

}

 

public String jdbcQuerry(String querryname) {

Connection conn;

String name = null;

try {

conn = this.getConnect();

PreparedStatement preparedStatement = (PreparedStatement) conn.prepareStatement("select * from users");

ResultSet resultSet = preparedStatement.executeQuery();

 

while (resultSet.next()) {

name = resultSet.getString(querryname);

 

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

 

return name;

}

 

public void insertJdbc() {

String sql = "insert into users (username,password) values('dariui','123321')";

Connection connection = null;

int i = 0;

try {

connection = this.getConnect();

PreparedStatement preparedStatement = (PreparedStatement) connection.prepareStatement(sql);

i = preparedStatement.executeUpdate();

preparedStatement.close();

connection.close();

} catch (Exception e) {

// TODO: handle exception

e.printStackTrace();

}

 

}

}

 

public class Test1 {

public static void main(String[] args) {

Test11 test11 = new Test11();

System.out.println(test11.jdbcQuerry("username"));

test11.insertJdbc();

System.out.println(test11.jdbcQuerry("username"));

 

}

 

}