首先要了解jdbc是什么?简单的说jdbc就是通过Java的方式连接数据库并对数据库进行简单的操作。连接数据首先必须要有驱动的概念,就是说你要连接数据库必须要驱动做基础,它其实就是一个连接的协议,我们每个人都必须要去遵循,也是说你要连接数据库大家公认的规则。
package cn.cil.Utls;
import java.sql.SQLException;
import java.util.Properties;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Driver;
public class InsertTest {
public void insert() throws Exception{
Connection con= getConnection();
String sql="delete from account_trans_group where groupname='12'";
java.sql.Statement sql1=con.createStatement();
sql1.execute(sql);
System.out.println("执行成功");
}
private Connection getConnection() throws SQLException {
// TODO Auto-generated method stub
Connection con;
String url="jdbc:mysql://localhost:3306/test";
String user="root";
String password="root";
Driver driver =new Driver();
Properties pros= new Properties();
pros.setProperty("user", user);
pros.setProperty("password", password);
con = (Connection) driver.connect(url, pros);
System.out.println(con);
return con;
}
public static void main(String args[]) throws Exception{
try
{InsertTest test1= new InsertTest();
test1.insert();
}
catch(Exception e){
e.printStackTrace();
}
}
}