package com.fill.jweb_jdbc_new;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
public class jdbcDemo {
public final static String URL="jdbc:mysql://127.0.0.1:3308/test";
public final static String USERNAME="root";
public final static String PWD="root";
/**
* jdbc操作数据库
*/
public static void insert(){
try {
//1.加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//2.获取数据库链接
Connection conn=(Connection) DriverManager.getConnection(URL, USERNAME, PWD);
//3.构造sql语句
String sql="insert into admin_sql_inject(name,pwd)values('haha','phaha')";
//4.构造一个statement实例(发送sql语句的载体)
Statement stat=(Statement) conn.createStatement();
//5.执行sql语句(其实是实现发送)
stat.executeUpdate(sql);
//6.关闭连接
stat.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void insert2(){
String name="beckham";
String pwd="9888";
try {
//1.加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//2.获取数据库链接
Connection conn=(Connection) DriverManager.getConnection(URL, USERNAME, PWD);
//3.构造sql语句
String sql="insert into admin_sql_inject(name,pwd)values('haha','phaha')";
//4.构造一个statement实例(发送sql语句的载体)
Statement stat=(Statement) conn.createStatement();
//5.执行sql语句(其实是实现发送)
stat.executeUpdate(sql);
//6.关闭连接
stat.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void update(){
try {
//1.加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//2.获取数据库链接
Connection conn=(Connection) DriverManager.getConnection(URL, USERNAME, PWD);
//3.构造sql语句
String sql="update admin_sql_inject set name='fhaha' where id=7";
//4.构造一个statement实例(发送sql语句的载体)
Statement stat=(Statement) conn.createStatement();
//5.执行sql语句(其实是实现发送)
stat.executeUpdate(sql);
//6.关闭连接
stat.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void delete(){
try {
//1.加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//2.获取数据库链接
Connection conn=(Connection) DriverManager.getConnection(URL, USERNAME, PWD);
//3.构造sql语句
String sql="delete from admin_sql_inject where id=7";
//4.构造一个statement实例(发送sql语句的载体)
Statement stat=(Statement) conn.createStatement();
//5.执行sql语句(其实是实现发送)
stat.executeUpdate(sql);
//6.关闭连接
stat.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* jdbc操作数据库
* 用ResultSet接口来处理结果集
* eg:
* ResultSet executeQuery(String sql)throws SQLException
* ResultSet常用方法:
* boolean next()
* int getInt();
* Date getDate();
* String getString();
*/
public static void query(){
//用ResultSet接口来获取结果
try {
//1.加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//2.获取数据库链接
Connection conn=(Connection) DriverManager.getConnection(URL, USERNAME, PWD);
//3.构造sql语句
String sql="select * from admin_sql_inject where 1 limit 3";
//4.构造一个statement实例(发送sql语句的载体)
Statement stat=(Statement) conn.createStatement();
//5.执行sql语句(其实是实现发送)
ResultSet rs=stat.executeQuery(sql);//此时结果还是放在数据库的
while(rs.next()){
System.out.println(rs.getString("name")+"=="+rs.getString("pwd")+"<br>");
}
//6.关闭连接
rs.close();
stat.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
//insert();
//update();
delete();
}
}