这段代码主要是怎样连接数据库,还有就是怎样添加数据和删除信息等,这是在练习中有所感悟的,代码有点乱,只是想记录自己的代码路程,留着以后自己观赏。
package newjava01;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
public class test01 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
// ?useUnicode=true&characterEncoding=utf-8可以解决乱码的问题,即编码
Connection con = DriverManager.getConnection(
"jdbc:mysql://localhost/sutdent?useUnicode=true&characterEncoding=utf8", "root", "123456");
Statement st = con.createStatement();
// //更新记录
String sql = "insert into stud values('28',21,'小龙')";
// sql="delete from stud where id='14'";
// String name="utf-8";
st.executeUpdate(sql);
// //返回结果
ResultSet resultSet = st.executeQuery("select*from stud");
ResultSetMetaData data = resultSet.getMetaData();
for (int i = 1; i <= data.getColumnCount(); i++) {
System.out.print(data.getColumnName(i) + "\t");
}
System.out.println();
while (resultSet.next()) {
for (int i = 1; i <= 3; i++) {
System.out.print(resultSet.getString(i) + "\t");
}
System.out.println();
}
}
}