以下为引用的内容:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.bean.NoticeBean;
public class JDBCTest {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try {
String driverName="com.mysql.jdbc.Driver";
Class.forName(driverName);
String url="jdbc:mysql://localhost:3306/java?
useUnicode=true&characterEncoding=gb2312";
conn=DriverManager.getConnection(url,"root","root");
System.out.println("连接MySql成功!!!");
stmt=null;
rs=null;
String strSql=null;
NoticeBean bean=null;
String title=null;
String content=null;
try {
title="标题";
content="内容";
strSql="INSERT INTO notice(title,content) VALUES('"+title+"','"+content+"')";
stmt=conn.createStatement();
stmt.executeUpdate(strSql);
System.out.println("插入语句执行成功:"+strSql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("插入失败");
}
strSql="select * from notice";
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(strSql);
if(rs.next()){
int id=rs.getInt("id");
title =rs.getString("title");
content=rs.getString("content");
if(rs.next()){
bean=new NoticeBean(id,title,content);
}
System.out.println("notice第一行数据是"+bean.getId()+" "+bean.getTitle()
+" "+bean.getContent());
}
摘要: try { strSql=delete from notice; stmt=conn.createStatement(); stmt.executeUpdate(strSql); System.out.println(删除完成); } catch (RuntimeException e) { // TODO Auto-generated catch block e.printStackT
try {
strSql="delete from notice";
stmt=conn.createStatement();
stmt.executeUpdate(strSql);
System.out.println("删除完成");
} catch (RuntimeException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("删除失败");
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(rs!=null){
rs.close();
rs=null;
}
if(stmt!=null){
stmt.close();
stmt=null;
}
if(conn!=null){
conn.close();
conn=null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}