没放对啊...
你用什么做服务器??
还有,你的url有问题........
你用什么做服务器??
还有,你的url有问题........
解决方案 »
- struts2 “No result defined for action and result input”的问题
- 推荐几本适合java初学者实用的书
- jbpm4.2发布新流程时,为什么会删除数据库里面的流程?
- 访问WebService时出现异常,请帮我看看这个异常信息是什么意思?
- 一个简单但菜鸟我却不懂的问题
- java 怎么判断一个文件是否为只读
- 如何把Elemnet的对象转换成String,输出到文本框?(新手莫笑)
- 我用的是JBOSS3.2.3,在JSP页面不能显示struts的标签库,JSP引擎总报错啊!!!
- jdbc中有没有这样的方法,
- 刚接触J2EE,EJB里面的Bean是个什么概念啊?比如实体Bean和会话Bean什么的。
- james好象不能接收外面服务器转发过来的邮件?可以自己编码增加这个功能吗?可否给点提示?
- CMP如果primary key包括两个字段时如何处理?
另外程序中有没有引入SQL包啊
然后就可以了...
如果你用其它做服务器(tomcat等),那么把它放到WEB-INF/lib目录下面也可以......
package com.davidflanagan.examples.sql;
import java.sql.*;
import java.io.*;public class ExecuteSQL {
public static void main(String[] args) {
Connection conn = null; // Our JDBC connection to the database server
try {
String driver = null, url = null, user = "", password = "";
for(int n = 0; n < args.length; n++) {
if (args[n].equals("-d")) driver = args[++n];
else if (args[n].equals("-u")) user = args[++n];
else if (args[n].equals("-p")) password = args[++n];
else if (url == null) url = args[n];
else throw new IllegalArgumentException("Unknown argument.");
}
if (url == null)
throw new IllegalArgumentException("No database specified"); if (driver != null) Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
Statement s = conn.createStatement();
BufferedReader in =
new BufferedReader(new InputStreamReader(System.in));
while(true) {
System.out.print("sql> "); // prompt the user
System.out.flush(); // make the prompt appear now.
String sql = in.readLine(); // get a line of input from user
if ((sql == null) || sql.equals("quit")) break;
if (sql.length() == 0) continue;
try {
boolean status = s.execute(sql);
do {
if (status) { // it was a query and returns a ResultSet
ResultSet rs = s.getResultSet(); // Get results
printResultsTable(rs, System.out); // Display them
}
else {
int numUpdates = s.getUpdateCount();
System.out.println("Ok. " + numUpdates +
" rows affected.");
}
status = s.getMoreResults();
} while(status || s.getUpdateCount() != -1);
}
catch (SQLException e) {
System.err.println("SQLException: " + e.getMessage()+ ":" +
e.getSQLState());
}
finally { // print out any warnings that occurred
SQLWarning w;
for(w=conn.getWarnings(); w != null; w=w.getNextWarning())
System.err.println("WARNING: " + w.getMessage() +
":" + w.getSQLState());
}
}
}
catch (Exception e) {
System.err.println(e);
if (e instanceof SQLException)
System.err.println("SQL State: " +
((SQLException)e).getSQLState());
System.err.println("Usage: java ExecuteSQL [-d <driver>] " +
"[-u <user>] [-p <password>] <database URL>");
}
finally {
try { conn.close(); } catch (Exception e) {}
}
}
static void printResultsTable(ResultSet rs, OutputStream output)
throws SQLException
{
PrintWriter out = new PrintWriter(output);
ResultSetMetaData metadata = rs.getMetaData();
int numcols = metadata.getColumnCount(); // how many columns
String[] labels = new String[numcols]; // the column labels
int[] colwidths = new int[numcols]; // the width of each
int[] colpos = new int[numcols]; // start position of each
int linewidth; // total width of table
linewidth = 1; // for the initial '|'.
for(int i = 0; i < numcols; i++) { // for each column
colpos[i] = linewidth; // save its position
labels[i] = metadata.getColumnLabel(i+1); // get its label
int size = metadata.getColumnDisplaySize(i+1);
if (size == -1) size = 30; // Some drivers return -1...
if (size > 500) size = 30; // Don't allow unreasonable sizes
int labelsize = labels[i].length();
if (labelsize > size) size = labelsize;
colwidths[i] = size + 1; // save the column the size
linewidth += colwidths[i] + 2; // increment total size
}
StringBuffer divider = new StringBuffer(linewidth);
StringBuffer blankline = new StringBuffer(linewidth);
for(int i = 0; i < linewidth; i++) {
divider.insert(i, '-');
blankline.insert(i, " ");
}
for(int i=0; i<numcols; i++) divider.setCharAt(colpos[i]-1,'+');
divider.setCharAt(linewidth-1, '+');
out.println(divider);
StringBuffer line = new StringBuffer(blankline.toString());
line.setCharAt(0, '|');
for(int i = 0; i < numcols; i++) {
int pos = colpos[i] + 1 + (colwidths[i]-labels[i].length())/2;
overwrite(line, pos, labels[i]);
overwrite(line, colpos[i] + colwidths[i], " |");
}
out.println(line);
out.println(divider);
while(rs.next()) {
line = new StringBuffer(blankline.toString());
line.setCharAt(0, '|');
for(int i = 0; i < numcols; i++) {
Object value = rs.getObject(i+1);
if (value != null)
overwrite(line, colpos[i] + 1, value.toString().trim());
overwrite(line, colpos[i] + colwidths[i], " |");
}
out.println(line);
}
out.println(divider);
out.flush();
}
static void overwrite(StringBuffer b, int pos, String s) {
int slen = s.length(); // string length
int blen = b.length(); // buffer length
if (pos+slen > blen) slen = blen-pos; // does it fit?
for(int i = 0; i < slen; i++) // copy string into buffer
b.setCharAt(pos+i, s.charAt(i));
}
}
我把参数去掉了!
去www.mysql.com下载。
classpath设置:C:\JBuilder9\jdk1.4\lib\dt.jar;C:\JBuilder9\jdk1.4\lib\tools.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\mysql-connector-java-3.0.8-stable-bin.jar
不是说了吗?
还有.......
上面的要那么麻烦吗?哎...import java.sql.*;
import java.io.*;public class sqltest{
public static void main(String[] args) {
try{
//add driver of database.
Class.forName("org.gjt.mm.mysql.Driver").newInstance() ;
}catch(Exception e){ }
try{
//get connection with database.
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname","username","password");
Statement stm = con.createStatement();
}catch(SQLException e){ System.out.println(e.toString()); }
}
}
然后要怎么用就随便你了.
我前面的一直url调用错误,应该加上:“//localhost:3306/”,现在没有错误了!
多谢各位!
最后一个问题,怎么才能把帖子的最大分数加到1000分啊?这可是关系到各位的分数啊,大家都来想办法!