mysql的学习(二)
经过一段时间的mysql的自学,总算是有点成果了,虽然对JDBC的很多知识还是不甚了解。。好了,先看东西:
package ctong;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* 1.增加数据-insert into game(name,type) values(?,?)
* public void dd2Table(String name,String type);
* public void add2Table(String name,String type,int id);
* 2.删除数据-delete from game where id = ?
* public void DelData(int id)
* 3.查找数据-select * from game
* public void SelectTables()
* 4.修改数据-update game set name=?,type=? where id=?
* public void upData(String name,String type,int id)
*
*
*
* @author ctong
*
*/
public class Mysql {
/*
数据库加载固定属性
*/
//mySql 中驱动类的名字就是其驱动包中的com.mysql.jdbc.Driver.class 类。
String driver="com.mysql.jdbc.Driver";
Connection con;
//jdbc:mysql://ip 地址: 端口号/数据库名字
String url="jdbc:mysql://localhost:3306/ctong";
String user="root";
//连接上数据库mysql
public void connection2MYSQL()
{
try {
Class.forName(driver);
//第三个属性是密码
con=DriverManager.getConnection(url,user,"");
if(!con.isClosed())
System.out.println("连接成功");
} catch (Exception e) {
e.printStackTrace();
}
}
//在表末增加一栏数据
public void add2Table(String name,String type)
{
try {
//预处理命令添加
PreparedStatement sql;
sql = con.prepareStatement("insert into game(name,type) values(?,?)");
sql.setString(1,name);
sql.setString(2,type);
sql.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
//增加一栏数据-----指定id
public void add2Table(String name,String type,int id)
{
try {
//预处理命令添加
PreparedStatement sql;
sql = con.prepareStatement("insert into game(name,type,id) values(?,?,?)");
sql.setString(1,name);
sql.setString(2,type);
sql.setInt(3, id);
sql.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
//查找表中所有数据
public void SelectTables(){
try {
// 执行sql语句
Statement statement = con.createStatement();
String sql = "select * from game";
ResultSet rs = statement.executeQuery(sql);
String name = "";
String type = "";
int id;
while (rs.next()) {
name = rs.getString("name");
type = rs.getString("type");
id=rs.getInt("id");
System.out.println("name =" + name + " type=" + type+" id="+id);
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
}
//删除一行数据
public void DelData(int id)
{
try {
PreparedStatement sql;
sql = con.prepareStatement("delete from game where id = ?");
sql.setInt(1,id);
sql.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
//修改一栏数据
public void upData(String name,String type,int id)
{
try {
PreparedStatement sql;
sql = con.prepareStatement("update game set name=?,type=? where id=?");
sql.setString(1,name);
sql.setString(2,type);
sql.setInt(3, id);
sql.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
//主函数
public static void main(String[] args)
{
Mysql mysql = new Mysql();
mysql.connection2MYSQL();
mysql.add2Table("CF", "dongzuo");
mysql.add2Table("DNF", "donzuo",5);
mysql.upData("LOL", "jishizhanlue", 2);
mysql.SelectTables();
try {
mysql.con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
这是我的数据库:
运行程序前:
运行程序后:
。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。深造中!