易截截图软件、单文件、免安装、纯绿色、仅160KB

jdbc连接mysql问题

Java code:
import java.sql.*;

public class DBTester1 {
public static void main(String[] args) throws Exception {
Connection con;
Statement stmt;
ResultSet rs;

Class.forName("com.mysql.jdbc.Driver");
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String dbUrl =
"jdbc:mysql://localhost:3306/STOREDB?useUnicode=true&characterEncoding=GB2312";
String dbUser = "dbuser";
String dbPwd ="1234";
con = java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
stmt= con.createStatement();

stmt.executeUpdate("insert into CUSTOMERS (NAME,AGE,ADDRESS)"
+"VALUES('小王',20,'上海')");
rs = stmt.executeQuery("SELECT ID,NAME,AGE,ADDRESS from CUSTOEMRS");
while(rs.next())
{
long id = rs.getLong(1);
String name = rs.getString(2);
int age = rs.getInt(3);
String address = rs.getString(4);

System.out.println("id="+id+",name="+name+",age="+age+",address="+address);
}
stmt.executeUpdate("delete from CUSTOMERS where name='小王'");
rs.close();
stmt.close();
con.close();


相关问答:

mysql如何实现高效的搜索?

一个行业网站,要实现的功能要求为:

一搜索表单可选搜索 产品/资讯/商家,搜索时希望先搜标题后全文,当前的数据量估计3万多,定位期望在百万级也可用。

数据类型为innodb,当前的方法是对关键词进行 ......

mysql的连接超时时间怎么设置 - VC/MFC / 数据库

我是用mysql自带的C API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("数据库连接失败") ......

MySql问题

MySql中插入当前时间的该怎么写啊?
now()

SQL code:

sql里是:
getdate()

引用
now()


学习

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

mysql查询--35分

mysql 中一个表中字段如下: id  value create_time 三个字段
如数据有: 
1  test1  2009-9-10
1  test2  2009-9-11
2  testg  2009-9-10
3  t ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号