java 连接mysql的问题,求解.
下载到mysql-connector-java-5.1.12-bin.jar后放在D盘,在环境变量里添加了classpath="D:\Program Files\Java\jdk1.6.0_19\lib",还是出现ClassNotFoundException异常,代码和异常如下:
import java.sql.*;
import java.util.Vector;
public class test
{
public static void main (String[] args)
{
Vector<String> results = new Vector<String>();
Connection con = null;
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","5647382910");
try{
Statement st = con.createStatement();
ResultSet rs = (ResultSet) st.executeQuery("SELECT * from staff");
while (rs.next()) {
String numb = rs.getString("name");
results.addElement(numb); }
st.close();
con.close();
}
catch (SQLException s){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
}
}
运�
相关问答：
当知道一个日期，如何把这个日期所在旬的前后两个日期取出
比如输入20090905，就输入20090901 20090910
输出20090901 20090910
取得天数后作一下判断再把这个方法用下void set(int field, int value)
......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
我已经按照教程上配置tomcat的server.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
<?xml version="1.0" encoding="utf-8" ?>
- <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical&q ......
